One or more column headings in datasheet are labeled '<>' due to design.
Cause:
Microsoft Access returns a '<>' as a column name for any 'null' value in a field in a Crosstab query.
Solution:
In the Query Design view, type 'Is Not Null' in the 'Criteria' cell of the desired field.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query in the list box. (The selected query is highlighted.)
4) Click 'Design'. (The query appears in Design view.)
5) Click in the 'Criteria' cell of the desired field name.
6) Type the following in the 'Criteria' cell:
Is Not Null
7) Repeat steps 5) and 6) for each desired field.
8) Select the 'File' menu and select 'Save' to save change to the query.
9) Select the 'Query' menu and select 'Run' to view the query results.
